2021燒結爐分析報表

Dataset statistics

Number of variables	29
Number of observations	19026
Missing cells	244163
Missing cells (%)	44.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.6 MiB
Average record size in memory	475.8 B

Variable types

DateTime	1
Categorical	3
Numeric	14
Unsupported	11

Alerts

`更換溫度時數` has constant value "180.0"	Constant
`原料分類` is highly correlated with `燒結溫度` and 1 other fields	High correlation
`燒結溫度` is highly correlated with `原料分類` and 1 other fields	High correlation
`速度` is highly correlated with `原料分類` and 1 other fields	High correlation
`重量(kg）` is highly correlated with `單重(g)` and 3 other fields	High correlation
`單重(g)` is highly correlated with `重量(kg）`	High correlation
`實際燒結時數` is highly correlated with `重量(kg）` and 2 other fields	High correlation
`待料時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`持溫時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`工時(H)` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`工時加總` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`重量(kg）` is highly correlated with `實際燒結時數` and 2 other fields	High correlation
`實際燒結時數` is highly correlated with `重量(kg）` and 2 other fields	High correlation
`待料時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`持溫時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`工時(H)` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`工時加總` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`原料分類` is highly correlated with `燒結溫度` and 1 other fields	High correlation
`燒結溫度` is highly correlated with `原料分類` and 1 other fields	High correlation
`速度` is highly correlated with `原料分類` and 1 other fields	High correlation
`重量(kg）` is highly correlated with `實際燒結時數` and 2 other fields	High correlation
`實際燒結時數` is highly correlated with `重量(kg）` and 2 other fields	High correlation
`待料時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`持溫時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`工時(H)` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`工時加總` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`爐號` is highly correlated with `原料分類` and 2 other fields	High correlation
`原料分類` is highly correlated with `爐號` and 2 other fields	High correlation
`速度` is highly correlated with `爐號` and 1 other fields	High correlation
`重量(kg）` is highly correlated with `工時(H)` and 1 other fields	High correlation
`實際燒結時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`待料時數` is highly correlated with `工時(H)` and 1 other fields	High correlation
`持溫時數` is highly correlated with `表單編號` and 2 other fields	High correlation
`表單編號` is highly correlated with `爐號` and 2 other fields	High correlation
`工時(H)` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`工時加總` is highly correlated with `重量(kg）` and 4 other fields	High correlation
`原料分類` has 4658 (24.5%) missing values	Missing
`原料` has 5601 (29.4%) missing values	Missing
`品編` has 4330 (22.8%) missing values	Missing
`批號` has 5066 (26.6%) missing values	Missing
`燒結溫度` has 4331 (22.8%) missing values	Missing
`速度` has 4348 (22.9%) missing values	Missing
`急冷` has 19026 (100.0%) missing values	Missing
`速率` has 19026 (100.0%) missing values	Missing
`快速脫臘` has 19026 (100.0%) missing values	Missing
`重量(kg）` has 5157 (27.1%) missing values	Missing
`實際燒結時數` has 4308 (22.6%) missing values	Missing
`待料時數` has 14841 (78.0%) missing values	Missing
`持溫時數` has 18964 (99.7%) missing values	Missing
`更換溫度時數` has 19025 (> 99.9%) missing values	Missing
`爐體維修時間` has 19026 (100.0%) missing values	Missing
`表單編號` has 15718 (82.6%) missing values	Missing
`確認者` has 696 (3.7%) missing values	Missing
`填表人` has 19026 (100.0%) missing values	Missing
`收料者` has 655 (3.4%) missing values	Missing
`盒數` has 17709 (93.1%) missing values	Missing
`箱數` has 5356 (28.2%) missing values	Missing
`燒結狀態` has 18247 (95.9%) missing values	Missing
`燒結溫度` is highly skewed (γ1 = 48.61856227)	Skewed
`原料` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`品編` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`批號` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`急冷` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`速率` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`快速脫臘` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`爐體維修時間` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`填表人` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`盒數` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`箱數` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`燒結狀態` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`數量` has 5130 (27.0%) zeros	Zeros

Reproduction

Analysis started	2022-04-24 15:48:46.323983
Analysis finished	2022-04-24 15:49:21.596917
Duration	35.27 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

日期
Date

Distinct	357
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	148.8 KiB

Minimum	2022-01-01 00:00:00
Maximum	2022-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

班別
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

C	9559
A	9463
B	2
CD	1
C	1

Length

Max length	2
Median length	1
Mean length	1.000105119
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	C
2nd row	C
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
C	9559	50.2%
A	9463	49.7%
B	2	< 0.1%
CD	1	< 0.1%
C	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
c	9560	50.2%
a	9463	49.7%
b	2	< 0.1%
cd	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

爐號
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.184011353

Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	8
Maximum	9
Range	8
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.46376928
Coefficient of variation (CV)	0.5888533927
Kurtosis	-1.221500607
Mean	4.184011353
Median Absolute Deviation (MAD)	2
Skewness	0.2527713456
Sum	79605
Variance	6.070159067
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	3546	18.6%
2	2780	14.6%
4	2233	11.7%
3	2233	11.7%
8	2051	10.8%
7	2022	10.6%
5	1956	10.3%
6	1773	9.3%
9	432	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3546	18.6%
2	2780	14.6%
3	2233	11.7%
4	2233	11.7%
5	1956	10.3%
6	1773	9.3%
7	2022	10.6%
8	2051	10.8%
9	432	2.3%

Value	Count	Frequency (%)
9	432	2.3%
8	2051	10.8%
7	2022	10.6%
6	1773	9.3%
5	1956	10.3%
4	2233	11.7%
3	2233	11.7%
2	2780	14.6%
1	3546	18.6%

原料分類
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	4658
Missing (%)	24.5%
Memory size	1024.0 KiB

1.0	12040
3.0	2296
2.0	28
24.0	4

Length

Max length	4
Median length	3
Mean length	3.000278396
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	12040	63.3%
3.0	2296	12.1%
2.0	28	0.1%
24.0	4	< 0.1%
(Missing)	4658	24.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	12040	83.8%
3.0	2296	16.0%
2.0	28	0.2%
24.0	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

原料
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	5601
Missing (%)	29.4%
Memory size	962.9 KiB

品編
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	4330
Missing (%)	22.8%
Memory size	678.6 KiB

批號
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	5066
Missing (%)	26.6%
Memory size	1005.6 KiB

燒結溫度
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	35
Distinct (%)	0.2%
Missing	4331
Missing (%)	22.8%
Infinite	0
Infinite (%)	0.0%
Mean	1123.898632

Minimum	50
Maximum	11220
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	50
5-th percentile	1120
Q1	1120
median	1120
Q3	1120
95-th percentile	1150
Maximum	11220
Range	11170
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	192.395128
Coefficient of variation (CV)	0.1711854811
Kurtosis	2559.557907
Mean	1123.898632
Median Absolute Deviation (MAD)	0
Skewness	48.61856227
Sum	16515690.4
Variance	37015.88528
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
1120	11802	62.0%
1150	1789	9.4%
1135	233	1.2%
1164	210	1.1%
1130	129	0.7%
1110	98	0.5%
1134	96	0.5%
1140	69	0.4%
1050	61	0.3%
1000	35	0.2%
Other values (25)	173	0.9%
(Missing)	4331	22.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50	8	< 0.1%
60	9	< 0.1%
110	2	< 0.1%
112	1	< 0.1%
113.4	1	< 0.1%
600	1	< 0.1%
700	12	0.1%
760	7	< 0.1%
800	27	0.1%
840	3	< 0.1%

Value	Count	Frequency (%)
11220	4	< 0.1%
11120	1	< 0.1%
1164	210	1.1%
1160	4	< 0.1%
1155	3	< 0.1%
1150	1789	9.4%
1144	2	< 0.1%
1140	69	0.4%
1135	233	1.2%
1134	96	0.5%

速度
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	21
Distinct (%)	0.1%
Missing	4348
Missing (%)	22.9%
Infinite	0
Infinite (%)	0.0%
Mean	59.26890585

Minimum	25
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	25
5-th percentile	50
Q1	60
median	60
Q3	60
95-th percentile	70
Maximum	90
Range	65
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.03598952
Coefficient of variation (CV)	0.1018407449
Kurtosis	5.808293575
Mean	59.26890585
Median Absolute Deviation (MAD)	0
Skewness	0.7073004766
Sum	869949
Variance	36.43316949
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
60	11265	59.2%
50	1963	10.3%
80	578	3.0%
55	348	1.8%
70	263	1.4%
53	95	0.5%
40	45	0.2%
33	26	0.1%
46	22	0.1%
65	17	0.1%
Other values (11)	56	0.3%
(Missing)	4348	22.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
25	8	< 0.1%
30	13	0.1%
33	26	0.1%
34	8	< 0.1%
40	45	0.2%
43	5	< 0.1%
45	6	< 0.1%
46	22	0.1%
48	9	< 0.1%
50	1963	10.3%

Value	Count	Frequency (%)
90	3	< 0.1%
80	578	3.0%
70	263	1.4%
65	17	0.1%
64	1	< 0.1%
63	1	< 0.1%
62	1	< 0.1%
61	1	< 0.1%
60	11265	59.2%
55	348	1.8%

急冷
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	19026
Missing (%)	100.0%
Memory size	148.8 KiB

速率
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	19026
Missing (%)	100.0%
Memory size	148.8 KiB

快速脫臘
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	19026
Missing (%)	100.0%
Memory size	148.8 KiB

重量(kg）
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2165
Distinct (%)	15.6%
Missing	5157
Missing (%)	27.1%
Infinite	0
Infinite (%)	0.0%
Mean	129.1806958

Minimum	0
Maximum	1629
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	0
5-th percentile	13.5
Q1	40
median	82
Q3	177.7
95-th percentile	388
Maximum	1629
Range	1629
Interquartile range (IQR)	137.7

Descriptive statistics

Standard deviation	128.7056065
Coefficient of variation (CV)	0.996322289
Kurtosis	5.176400403
Mean	129.1806958
Median Absolute Deviation (MAD)	54
Skewness	1.958436042
Sum	1791607.07
Variance	16565.13315
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	530	2.8%
40	468	2.5%
60	399	2.1%
80	259	1.4%
100	214	1.1%
120	165	0.9%
140	157	0.8%
10	122	0.6%
51.8	119	0.6%
160	118	0.6%
Other values (2155)	11318	59.5%
(Missing)	5157	27.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.5	1	< 0.1%
0.7	2	< 0.1%
0.8	2	< 0.1%
1	4	< 0.1%
1.2	2	< 0.1%
1.3	1	< 0.1%
1.5	5	< 0.1%
1.6	2	< 0.1%
1.7	1	< 0.1%

Value	Count	Frequency (%)
1629	1	< 0.1%
898.9	1	< 0.1%
862.4	1	< 0.1%
794.5	1	< 0.1%
780	1	< 0.1%
739.2	10	0.1%
709.5	1	< 0.1%
707.7	1	< 0.1%
707.4	10	0.1%
691.6	26	0.1%

單重(g)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1391
Distinct (%)	7.3%
Missing	23
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	139.6020938

Minimum	0.09
Maximum	4517
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	0.09
5-th percentile	1
Q1	1
median	22.05
Q3	271.5
95-th percentile	540
Maximum	4517
Range	4516.91
Interquartile range (IQR)	270.5

Descriptive statistics

Standard deviation	199.0073181
Coefficient of variation (CV)	1.425532474
Kurtosis	17.94699145
Mean	139.6020938
Median Absolute Deviation (MAD)	21.05
Skewness	2.073775351
Sum	2652858.588
Variance	39603.91266
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	4676	24.6%
540	1003	5.3%
440	761	4.0%
393	742	3.9%
313.7	346	1.8%
4.48	332	1.7%
422	279	1.5%
4.6	256	1.3%
89	197	1.0%
639	151	0.8%
Other values (1381)	10260	53.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.09	3	< 0.1%
0.12	3	< 0.1%
0.15	4	< 0.1%
0.25	6	< 0.1%
0.26	11	0.1%
0.27	5	< 0.1%
0.28	17	0.1%
0.3	2	< 0.1%
0.31	1	< 0.1%
0.33	4	< 0.1%

Value	Count	Frequency (%)
4517	1	< 0.1%
3689	1	< 0.1%
1163	1	< 0.1%
1010	2	< 0.1%
1002	2	< 0.1%
1000	2	< 0.1%
981	2	< 0.1%
972.6	3	< 0.1%
875	2	< 0.1%
874.5	5	< 0.1%

數量
Real number (ℝ_≥0)

ZEROS

Distinct	7136
Distinct (%)	37.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3336.355441

Minimum	0
Maximum	553571.4286
Zeros	5130
Zeros (%)	27.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	611.944056
Q3	2733.269263
95-th percentile	16807.3286
Maximum	553571.4286
Range	553571.4286
Interquartile range (IQR)	2733.269263

Descriptive statistics

Standard deviation	8376.277344
Coefficient of variation (CV)	2.510607006
Kurtosis	1002.525845
Mean	3336.355441
Median Absolute Deviation (MAD)	611.944056
Skewness	18.27410708
Sum	63477498.63
Variance	70162022.15
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5130	27.0%
800	124	0.7%
95.92592593	116	0.6%
120	89	0.5%
71.85185185	80	0.4%
1600	70	0.4%
600	67	0.4%
90	67	0.4%
224.8815166	56	0.3%
560	55	0.3%
Other values (7126)	13172	69.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5130	27.0%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
7.962962963	2	< 0.1%
10	4	< 0.1%
10.92592593	1	< 0.1%
12	2	< 0.1%
12.5698324	1	< 0.1%

Value	Count	Frequency (%)
553571.4286	1	< 0.1%
132558.1395	1	< 0.1%
122674.4186	1	< 0.1%
121428.5714	1	< 0.1%
116000	1	< 0.1%
112903.2258	1	< 0.1%
112500	1	< 0.1%
101382.4885	1	< 0.1%
93023.25581	1	< 0.1%
92105.26316	1	< 0.1%

實際燒結時數
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	94
Distinct (%)	0.6%
Missing	4308
Missing (%)	22.6%
Infinite	0
Infinite (%)	0.0%
Mean	202.9660959

Minimum	5
Maximum	480
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	5
5-th percentile	30
Q1	90
median	180
Q3	240
95-th percentile	480
Maximum	480
Range	475
Interquartile range (IQR)	150

Descriptive statistics

Standard deviation	139.2607303
Coefficient of variation (CV)	0.6861280434
Kurtosis	-0.4115739012
Mean	202.9660959
Median Absolute Deviation (MAD)	85
Skewness	0.7417691164
Sum	2987255
Variance	19393.551
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
240	2882	15.1%
480	1828	9.6%
60	967	5.1%
120	834	4.4%
90	678	3.6%
180	665	3.5%
150	517	2.7%
30	500	2.6%
210	319	1.7%
40	291	1.5%
Other values (84)	5237	27.5%
(Missing)	4308	22.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	93	0.5%
10	192	1.0%
15	49	0.3%
20	152	0.8%
25	46	0.2%
30	500	2.6%
35	41	0.2%
40	291	1.5%
45	81	0.4%
50	234	1.2%

Value	Count	Frequency (%)
480	1828	9.6%
470	1	< 0.1%
465	2	< 0.1%
460	12	0.1%
455	2	< 0.1%
450	45	0.2%
445	1	< 0.1%
440	25	0.1%
435	6	< 0.1%
430	18	0.1%

待料時數
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	79
Distinct (%)	1.9%
Missing	14841
Missing (%)	78.0%
Infinite	0
Infinite (%)	0.0%
Mean	298.9713262

Minimum	10
Maximum	720
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	10
5-th percentile	60
Q1	240
median	240
Q3	480
95-th percentile	480
Maximum	720
Range	710
Interquartile range (IQR)	240

Descriptive statistics

Standard deviation	146.959868
Coefficient of variation (CV)	0.4915517147
Kurtosis	-1.207339039
Mean	298.9713262
Median Absolute Deviation (MAD)	120
Skewness	0.05814542112
Sum	1251195
Variance	21597.20281
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
240	1585	8.3%
480	1433	7.5%
60	133	0.7%
180	116	0.6%
120	115	0.6%
90	85	0.4%
30	73	0.4%
150	72	0.4%
210	55	0.3%
80	29	0.2%
Other values (69)	489	2.6%
(Missing)	14841	78.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	6	< 0.1%
15	2	< 0.1%
20	21	0.1%
25	5	< 0.1%
30	73	0.4%
35	1	< 0.1%
40	18	0.1%
45	4	< 0.1%
50	21	0.1%
55	3	< 0.1%

Value	Count	Frequency (%)
720	4	< 0.1%
570	1	< 0.1%
480	1433	7.5%
450	8	< 0.1%
440	6	< 0.1%
430	3	< 0.1%
420	23	0.1%
415	1	< 0.1%
410	3	< 0.1%
400	3	< 0.1%

持溫時數
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	20
Distinct (%)	32.3%
Missing	18964
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	259.516129

Minimum	20
Maximum	480
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	20
5-th percentile	41
Q1	146.25
median	240
Q3	420
95-th percentile	480
Maximum	480
Range	460
Interquartile range (IQR)	273.75

Descriptive statistics

Standard deviation	152.4787265
Coefficient of variation (CV)	0.5875500958
Kurtosis	-1.179696458
Mean	259.516129
Median Absolute Deviation (MAD)	120
Skewness	0.2867041535
Sum	16090
Variance	23249.76203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
480	15	0.1%
240	13	0.1%
120	5	< 0.1%
60	5	< 0.1%
180	3	< 0.1%
200	2	< 0.1%
150	2	< 0.1%
210	2	< 0.1%
360	2	< 0.1%
30	2	< 0.1%
Other values (10)	11	0.1%
(Missing)	18964	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	1	< 0.1%
30	2	< 0.1%
40	1	< 0.1%
60	5	< 0.1%
120	5	< 0.1%
130	1	< 0.1%
145	1	< 0.1%
150	2	< 0.1%
170	1	< 0.1%
180	3	< 0.1%

Value	Count	Frequency (%)
480	15	0.1%
420	2	< 0.1%
360	2	< 0.1%
330	1	< 0.1%
300	1	< 0.1%
270	1	< 0.1%
240	13	0.1%
210	2	< 0.1%
200	2	< 0.1%
185	1	< 0.1%

更換溫度時數
Categorical

CONSTANT
MISSING
REJECTED

Distinct	1
Distinct (%)	100.0%
Missing	19025
Missing (%)	> 99.9%
Memory size	743.3 KiB

180.0	1

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	100.0%

Sample

1st row	180.0

Common Values

Value	Count	Frequency (%)
180.0	1	< 0.1%
(Missing)	19025	> 99.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
180.0	1	100.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

爐體維修時間
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	19026
Missing (%)	100.0%
Memory size	148.8 KiB

表單編號
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	562
Distinct (%)	17.0%
Missing	15718
Missing (%)	82.6%
Infinite	0
Infinite (%)	0.0%
Mean	1319.492443

Minimum	1
Maximum	4415
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	1
5-th percentile	29.35
Q1	364
median	629
Q3	2525
95-th percentile	4282
Maximum	4415
Range	4414
Interquartile range (IQR)	2161

Descriptive statistics

Standard deviation	1253.793839
Coefficient of variation (CV)	0.9502091851
Kurtosis	-0.3834289233
Mean	1319.492443
Median Absolute Deviation (MAD)	413
Skewness	0.8984607071
Sum	4364881
Variance	1571998.99
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2858	134	0.7%
370	10	0.1%
585	10	0.1%
616	10	0.1%
1045	10	0.1%
327	10	0.1%
954	10	0.1%
602	10	0.1%
2336	10	0.1%
361	10	0.1%
Other values (552)	3084	16.2%
(Missing)	15718	82.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6	< 0.1%
2	7	< 0.1%
3	7	< 0.1%
4	8	< 0.1%
5	9	< 0.1%
6	5	< 0.1%
7	7	< 0.1%
8	8	< 0.1%
9	6	< 0.1%
10	4	< 0.1%

Value	Count	Frequency (%)
4415	7	< 0.1%
4414	4	< 0.1%
4413	4	< 0.1%
4412	4	< 0.1%
4411	4	< 0.1%
4410	7	< 0.1%
4409	2	< 0.1%
4408	10	0.1%
4407	10	0.1%
4406	2	< 0.1%

確認者
Real number (ℝ_≥0)

MISSING

Distinct	44
Distinct (%)	0.2%
Missing	696
Missing (%)	3.7%
Infinite	0
Infinite (%)	0.0%
Mean	250.2063501

Minimum	0
Maximum	3698
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	0
5-th percentile	49
Q1	248
median	248
Q3	325
95-th percentile	398
Maximum	3698
Range	3698
Interquartile range (IQR)	77

Descriptive statistics

Standard deviation	149.3154731
Coefficient of variation (CV)	0.5967693188
Kurtosis	194.0862827
Mean	250.2063501
Median Absolute Deviation (MAD)	38
Skewness	9.255249186
Sum	4586282.398
Variance	22295.11052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
248	5806	30.5%
49	3596	18.9%
286	3484	18.3%
398	1809	9.5%
348	1502	7.9%
325	1455	7.6%
300	384	2.0%
283	217	1.1%
48	8	< 0.1%
346	5	< 0.1%
Other values (34)	64	0.3%
(Missing)	696	3.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.398	1	< 0.1%
9	2	< 0.1%
19	4	< 0.1%
28	1	< 0.1%
30	2	< 0.1%
38	2	< 0.1%
48	8	< 0.1%
49	3596	18.9%
94	2	< 0.1%

Value	Count	Frequency (%)
3698	2	< 0.1%
3398	4	< 0.1%
3348	2	< 0.1%
3325	1	< 0.1%
3286	4	< 0.1%
3248	4	< 0.1%
3049	1	< 0.1%
2836	1	< 0.1%
2483	1	< 0.1%
2448	1	< 0.1%

填表人
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	19026
Missing (%)	100.0%
Memory size	148.8 KiB

收料者
Real number (ℝ_≥0)

MISSING

Distinct	49
Distinct (%)	0.3%
Missing	655
Missing (%)	3.4%
Infinite	0
Infinite (%)	0.0%
Mean	327.8369501

Minimum	3.61
Maximum	4243
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	3.61
5-th percentile	94
Q1	318
median	346
Q3	368
95-th percentile	369
Maximum	4243
Range	4239.39
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	180.7938518
Coefficient of variation (CV)	0.5514749077
Kurtosis	254.3737228
Mean	327.8369501
Median Absolute Deviation (MAD)	22
Skewness	14.55732574
Sum	6022692.61
Variance	32686.41685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
361	2639	13.9%
369	2587	13.6%
368	2553	13.4%
324	2549	13.4%
318	2504	13.2%
346	2231	11.7%
217	2146	11.3%
94	970	5.1%
348	25	0.1%
319	17	0.1%
Other values (39)	150	0.8%
(Missing)	655	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.61	1	< 0.1%
9	1	< 0.1%
27	1	< 0.1%
31	1	< 0.1%
38	1	< 0.1%
49	6	< 0.1%
94	970	5.1%
102	4	< 0.1%
149	1	< 0.1%
217	2146	11.3%

Value	Count	Frequency (%)
4243	1	< 0.1%
3969	1	< 0.1%
3699	4	< 0.1%
3668	2	< 0.1%
3661	5	< 0.1%
3624	1	< 0.1%
3613	2	< 0.1%
3483	1	< 0.1%
3469	3	< 0.1%
3368	3	< 0.1%

盒數
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	17709
Missing (%)	93.1%
Memory size	600.0 KiB

箱數
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	5356
Missing (%)	28.2%
Memory size	648.1 KiB

燒結狀態
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18247
Missing (%)	95.9%
Memory size	597.8 KiB

工時(H)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	97
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.72711027

Minimum	0
Maximum	12
Zeros	61
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.5
Q1	1.666666667
median	4
Q3	4.5
95-th percentile	8
Maximum	12
Range	12
Interquartile range (IQR)	2.833333333

Descriptive statistics

Standard deviation	2.447716131
Coefficient of variation (CV)	0.6567329522
Kurtosis	-0.7629773019
Mean	3.72711027
Median Absolute Deviation (MAD)	2
Skewness	0.5674176199
Sum	70912
Variance	5.991314257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	4480	23.5%
8	3277	17.2%
1	1105	5.8%
2	954	5.0%
3	785	4.1%
1.5	763	4.0%
2.5	591	3.1%
0.5	574	3.0%
3.5	376	2.0%
0.666666667	310	1.6%
Other values (87)	5811	30.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	61	0.3%
0.083333333	93	0.5%
0.166666667	198	1.0%
0.25	51	0.3%
0.333333333	174	0.9%
0.416666667	51	0.3%
0.5	574	3.0%
0.583333333	42	0.2%
0.666666667	310	1.6%
0.75	85	0.4%

Value	Count	Frequency (%)
12	4	< 0.1%
9.5	1	< 0.1%
8	3277	17.2%
7.833333333	1	< 0.1%
7.75	2	< 0.1%
7.666666667	12	0.1%
7.583333333	2	< 0.1%
7.5	52	0.3%
7.416666667	1	< 0.1%
7.333333333	31	0.2%

工時加總
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	97
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	223.6266162

Minimum	0
Maximum	720
Zeros	61
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	148.8 KiB

Quantile statistics

Minimum	0
5-th percentile	30
Q1	100
median	240
Q3	270
95-th percentile	480
Maximum	720
Range	720
Interquartile range (IQR)	170

Descriptive statistics

Standard deviation	146.8629679
Coefficient of variation (CV)	0.6567329522
Kurtosis	-0.7629773019
Mean	223.6266162
Median Absolute Deviation (MAD)	120
Skewness	0.5674176199
Sum	4254720
Variance	21568.73133
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
240	4480	23.5%
480	3277	17.2%
60	1105	5.8%
120	954	5.0%
180	785	4.1%
90	763	4.0%
150	591	3.1%
30	574	3.0%
210	376	2.0%
40	310	1.6%
Other values (87)	5811	30.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	61	0.3%
5	93	0.5%
10	198	1.0%
15	51	0.3%
20	174	0.9%
25	51	0.3%
30	574	3.0%
35	42	0.2%
40	310	1.6%
45	85	0.4%

Value	Count	Frequency (%)
720	4	< 0.1%
570	1	< 0.1%
480	3277	17.2%
470	1	< 0.1%
465	2	< 0.1%
460	12	0.1%
455	2	< 0.1%
450	52	0.3%
445	1	< 0.1%
440	31	0.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	日期	班別	爐號	原料分類	原料	品編	批號	燒結溫度	速度	急冷	速率	快速脫臘	重量(kg）	單重(g)	數量	實際燒結時數	待料時數	持溫時數	更換溫度時數	爐體維修時間	表單編號	確認者	填表人	收料者	盒數	箱數	燒結狀態	工時(H)	工時加總
0	2022-01-01	C	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	90.0	NaN	NaN	NaN	NaN	325.0	NaN	369.0	NaN	NaN	NaN	1.500000	90
1	2022-01-01	C	1	1.0	25	6808	201230A	1120.0	60.0	NaN	NaN	NaN	90.0	8.45	10650.887570	390.0	NaN	NaN	NaN	NaN	NaN	325.0	NaN	369.0	NaN	5	NaN	6.500000	390
2	2022-01-01	A	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	60.0	NaN	NaN	NaN	NaN	49.0	NaN	346.0	NaN	NaN	NaN	1.000000	60
3	2022-01-01	A	1	1.0	15-1	8005	201231A	1120.0	60.0	NaN	NaN	NaN	300.0	140.00	2142.857143	420.0	NaN	NaN	NaN	NaN	NaN	498.0	NaN	368.0	NaN	15	NaN	7.000000	420
4	2022-01-01	A	1	1.0	15-1	8005	201231A	1120.0	60.0	NaN	NaN	NaN	147.5	140.00	1053.571429	200.0	NaN	NaN	NaN	NaN	NaN	248.0	NaN	368.0	NaN	8	NaN	3.333333	200
5	2022-01-01	A	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	40.0	NaN	NaN	NaN	NaN	248.0	NaN	368.0	NaN	NaN	NaN	0.666667	40
6	2022-01-01	C	1	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	240.0	NaN	NaN	NaN	NaN	248.0	NaN	368.0	NaN	NaN	NaN	4.000000	240
7	2022-01-01	C	2	1.0	5-7	4454	201230A	1120.0	60.0	NaN	NaN	NaN	15.4	138.00	111.594203	60.0	NaN	NaN	NaN	NaN	NaN	325.0	NaN	369.0	NaN	1	NaN	1.000000	60
8	2022-01-01	C	2	1.0	5-3	4666	201231A	1120.0	60.0	NaN	NaN	NaN	80.0	57.20	1398.601399	420.0	NaN	NaN	NaN	NaN	NaN	325.0	NaN	369.0	NaN	4	NaN	7.000000	420
9	2022-01-01	A	2	1.0	5-3	4666	201231A	1120.0	60.0	NaN	NaN	NaN	70.0	57.20	1223.776224	270.0	NaN	NaN	NaN	NaN	NaN	49.0	NaN	368.0	NaN	4	NaN	4.500000	270

Last rows

	日期	班別	爐號	原料分類	原料	品編	批號	燒結溫度	速度	急冷	速率	快速脫臘	重量(kg）	單重(g)	數量	實際燒結時數	待料時數	持溫時數	更換溫度時數	爐體維修時間	表單編號	確認者	填表人	收料者	盒數	箱數	燒結狀態	工時(H)	工時加總
19016	2022-12-31	C	8	1.0	8-2	6556	211224A	1120.0	60.0	NaN	NaN	NaN	387.8	128.25	3023.781676	480.0	NaN	NaN	NaN	NaN	535.0	49.0	NaN	318.0	NaN	18	NaN	8.000000	480
19017	2022-12-31	A	8	1.0	8-2	6556	211224A	1120.0	60.0	NaN	NaN	NaN	409.3	128.25	3191.423002	385.0	NaN	NaN	NaN	NaN	535.0	286.0	NaN	324.0	NaN	19	NaN	6.416667	385
19018	2022-12-31	A	8	1.0	20-2	6534	NaN	1120.0	60.0	NaN	NaN	NaN	92.1	209.00	440.669856	95.0	NaN	NaN	NaN	NaN	535.0	286.0	NaN	324.0	NaN	15	NaN	1.583333	95
19019	2022-12-31	A	8	1.0	15-4	3394	211227A	1120.0	60.0	NaN	NaN	NaN	200.0	308.00	649.350649	240.0	NaN	NaN	NaN	NaN	535.0	248.0	NaN	324.0	NaN	10	NaN	4.000000	240
19020	2022-12-31	C	8	1.0	15-4	3394	211227A	1120.0	60.0	NaN	NaN	NaN	200.0	308.00	649.350649	240.0	NaN	NaN	NaN	NaN	535.0	248.0	NaN	369.0	NaN	10	NaN	4.000000	240
19021	2022-12-31	C	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	480.0	NaN	NaN	NaN	96.0	49.0	NaN	361.0	NaN	NaN	NaN	8.000000	480
19022	2022-12-31	A	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	480.0	NaN	NaN	NaN	96.0	286.0	NaN	346.0	NaN	NaN	NaN	8.000000	480
19023	2022-12-31	A	9	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	0.000000	NaN	210.0	NaN	NaN	NaN	96.0	248.0	NaN	346.0	NaN	NaN	NaN	3.500000	210
19024	2022-12-31	A	9	1.0	17	3609	211229C	800.0	50.0	NaN	NaN	NaN	NaN	28.50	0.000000	30.0	NaN	NaN	NaN	NaN	96.0	248.0	NaN	393.0	NaN	NaN	NaN	0.500000	30
19025	2022-12-31	C	9	1.0	17	3609	211229C	800.0	50.0	NaN	NaN	NaN	120.0	28.50	4210.526316	240.0	NaN	NaN	NaN	NaN	96.0	248.0	NaN	217.0	NaN	6	NaN	4.000000	240

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows